<!--Copyright (c) 1999, 2013 Oracle and/or its affiliates.  All rights reserved.-->
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta http-equiv="content-type"
 content="text/html; charset=ISO-8859-1">
  <title>Sequence Commands</title>
</head>
<body>
<h2><a name="Database Commands"></a>Sequence Commands</h2>
<b>&gt; berkdb sequence [-auto_commit] [-txn txnid] [-create] </b><br>
<div style="margin-left: 40px;">&nbsp;Implements <a
 href="file:///home/ubell/db.new/docs/seq/seq_open.html">DBENV-&gt;sequence</a>
function. The above options have the usual meanings.<br>
</div>
<span style="font-weight: bold;">[-cachesize]</span><br>
<div style="margin-left: 40px;">Set the size of the cache in this
handle.<br>
</div>
<span style="font-weight: bold;">[-inc]<br>
</span>
<div style="margin-left: 40px;">Sequence increments..<br>
</div>
<span style="font-weight: bold;">[-dec]<br>
</span>
<div style="margin-left: 40px;">Sequence decrements.<br>
</div>
<span style="font-weight: bold;">[-init integer]<br>
</span>
<div style="margin-left: 40px;">Set the initial value for sequence.<br>
</div>
<span style="font-weight: bold;">[-max integer]</span><br>
<div style="margin-left: 40px;">Set the maximum value for the sequence.<br>
</div>
<span style="font-weight: bold;">[-max integer]<br>
</span>
<div style="margin-left: 40px;">Set the minimum value for the sequence.<br>
</div>
<span style="font-weight: bold;">[-wrap]</span><br>
<div style="margin-left: 40px;">Wrap around at max or min.<br>
</div>
<span style="font-weight: bold;"><span style="font-style: italic;">db</span>
key<br>
</span>
<div style="margin-left: 40px;">Database handle and key of sequence.<br>
</div>
<hr width="100%"><span style="font-style: italic;"><span
 style="font-weight: bold;">&gt; seq </span></span><span
 style="font-weight: bold;">get [-txn <span style="font-style: italic;">txn</span>]
[-auto_commit] [-nosync] delta<br>
</span>
<div style="margin-left: 40px;">Get the nexted sequence value and
increment the sequence by <span style="font-weight: bold;">delta</span>.<br>
</div>
<hr width="100%"><span style="font-weight: bold;">&gt; <span
 style="font-style: italic;">seq </span>close</span><br>
<div style="margin-left: 40px;">Close the sequence<br>
</div>
<br>
<hr width="100%"><span style="font-weight: bold;">&gt; <span
 style="font-style: italic;">seq</span> remove [-auto_commit] [-nosync]
[-txn] <br>
</span>
<div style="margin-left: 40px;">Remove the sequence.<br>
</div>
<hr width="100%"><span style="font-weight: bold;">&gt; <span
 style="font-style: italic;">seq </span>get_cachesize<br>
</span>
<div style="margin-left: 40px;">Return the size of the cache.<br>
</div>
<hr width="100%"><span style="font-weight: bold;">&gt; <span
 style="font-style: italic;">seq </span>get_db<br>
</span>
<div style="margin-left: 40px;">Return the underlying db handle.<br>
</div>
<hr width="100%"><span style="font-weight: bold;">&gt; <span
 style="font-style: italic;">seq </span>get_flags</span><br>
<div style="margin-left: 40px;">Return the flags set on create.<br>
</div>
<hr width="100%"><span style="font-weight: bold;">&gt; <span
 style="font-style: italic;">seq</span> get_range<br>
</span>
<div style="margin-left: 40px;">Return the min and max set at create.<br>
</div>
<hr width="100%"><span style="font-weight: bold;">&gt; <span
 style="font-style: italic;">seq </span>stat<br>
</span>
<div style="margin-left: 40px;">Implements the <a
 href="../../docs/seq/seq_stat.html">SEQUENCE-&gt;stat</a> function.<br>
</div>
<hr width="100%">
</body>
</html>
